package com.pointwest.pls.dao;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import com.pointwest.pls.constant.DBConstant;

public class ProjectDAO{
	
	
	/**get current projects of employee using employee id
	 * @param employeeID
	 * @return
	 * @throws ClassNotFoundException
	 * @throws SQLException
	 * @throws Exception
	 */
	public ArrayList<Map<String, String>> getProjectByID(int employeeID) throws ClassNotFoundException, SQLException, Exception{
		BaseDAO baseDAO = new BaseDAO();
		ArrayList<String> params = new ArrayList<String>();
		ArrayList<String> columns = new ArrayList<String>();
		ArrayList<Map<String, String>> searchList = new ArrayList<Map<String, String>>();
		
		params.add(String.valueOf(employeeID));
		
		columns.add(DBConstant.COL_PROJECT_DESC);
		
		searchList = baseDAO.retrieveListValue(DBConstant.SQL_SEARCH_PROJECT_BY_ID, params, columns);		
		return searchList;
	}

}
